|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4418
|
Posted - 2014.12.08 17:32:43 -
[1] - Quote
Hel O'Ween wrote:CCP FoxFour wrote:I should point out there is a new table added along with a new column added to an old table. ... and those tables are ...?!?
dgmExpressions.
It's not going to be an easy table to use, but it's one that's been asked for, for a fair time.
One more nail in the coffin of 'we need to cache scrape'
It's one I'm exceptionally happy to see.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4418
|
Posted - 2014.12.08 18:06:29 -
[2] - Quote
CCP FoxFour wrote:did you find the new column as well Steve?
Not been looking yet too busy converting (with breaks to cough my lungs up)
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4419
|
Posted - 2014.12.08 18:46:19 -
[3] - Quote
https://www.fuzzwork.co.uk/dump/mysql56-rhea-1.0-109013.tbz2
https://www.fuzzwork.co.uk/dump/rhea-1.0-109013/
https://www.fuzzwork.co.uk/dump/rhea-1.0-109013/postgres-rhea-1.109013.sql.bz2
https://www.fuzzwork.co.uk/dump/rhea-1.0-109013/eve.db.bz2
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4420
|
Posted - 2014.12.08 19:07:02 -
[4] - Quote
Airi Cho wrote:mysql56-rhea-1.0-109013.tbz2, gzip compressed data ....
maybe rename or recompress :)
I have no idea what you're talking about, it works fine for me...
/me deletes the lines doing the recompression from his history
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4420
|
Posted - 2014.12.08 19:41:59 -
[5] - Quote
https://www.fuzzwork.co.uk/dump/rhea-1.0-109013/diff.txt.bz2 is the difference between the phoebe and rhea databases.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4422
|
Posted - 2014.12.08 23:04:43 -
[6] - Quote
Zifrian wrote:Aineko Macx wrote:ramAssemblyLineTypeDetailPerCategory table is missing data for categoryID=9, again. Thanks for checking this. It's a pretty important table for my facility processing. Also, it seems like there is a record missing for ancient relics here (category = 34) for the experimental lab. There are categories for strategic cruiser and subsystems though? That doesn't make much sense to me since you can't invent from those. Am I reading this table incorrectly? Finally, can someone link me or explain what the new table and field is? I must have missed it. Thanks for the early release FF.
dgmExpressions
It contains the details for how all the modifers hook together.
And a new column on dgmEffects (which overrides the expression, iirc)
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4422
|
Posted - 2014.12.08 23:54:23 -
[7] - Quote
Daimian Mercer wrote:CCP FoxFour wrote:Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table. I don't think those are exported in the SDE. From what I understand they are actually hidden beacons that are spawned in the system, so unless we exported the contents of the system they wouldn't be included. :( Ooo, tricky
select * from mapDenormalize where typeid=30575;
mapDenormalize for the win.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4422
|
Posted - 2014.12.09 00:06:28 -
[8] - Quote
Zifrian wrote:Steve Ronuken wrote:Zifrian wrote:Aineko Macx wrote:ramAssemblyLineTypeDetailPerCategory table is missing data for categoryID=9, again. Thanks for checking this. It's a pretty important table for my facility processing. Also, it seems like there is a record missing for ancient relics here (category = 34) for the experimental lab. There are categories for strategic cruiser and subsystems though? That doesn't make much sense to me since you can't invent from those. Am I reading this table incorrectly? Finally, can someone link me or explain what the new table and field is? I must have missed it. Thanks for the early release FF. dgmExpressions It contains the details for how all the modifers hook together. And a new column on dgmEffects (which overrides the expression, iirc) Thanks, I meant does...not is...so tired today... Modifiers for what? Skills or is this where we can get bonuses for the ships based on skills too?
Basically, it's the data that programs like EFT and pyfa require, and currently rip out of the cache. I'm not sure how it all works though.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4430
|
Posted - 2014.12.09 16:19:41 -
[9] - Quote
Siklone wrote:Steve @ Fuzzwork - thanks for posting these! The custom Postgres format you used (pg_dump -Fc) is already compressed, so you don't need to bzip them :)
In case anyone wants to get this into the text format:
~> bzip2 -d postgres-rhea-1.109013.sql.bz2 && pg_restore postgres-rhea-1.109013.sql > postgres-rhea-1.109013.txtdmp.sql
That'd be a sideeffect of bzip2 *
Just as a tip:
bunzip2 -c postgres-rhea-1.109013.sql.bz2 | pg_restore > postgres-rhea-1.109013.txtdmp.sql
if you don't want that pesky intermediate file ;)
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4488
|
Posted - 2014.12.13 22:20:16 -
[10] - Quote
Verite Rendition wrote:Thanks for the per-table MySQL dumps, Daimian. It made updating the map a piece of cake.
psst. Not from Daimian.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
|